CreateNotificationTable1717147942177.up - Code Metrics - Inspection of "feat: mattermost notifier" - fairnesscoop/permacoop - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#436)

by Mathieu

created 2024-06-28 09:17 UTC

CreateNotificationTable1717147942177.up A

↳ Parent: CreateNotificationTable1717147942177

Complexity

Conditions

Size

Total Lines	10
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	5
dl	0
loc	10
rs	10
c	0
b	0
f	0
cc	1

import { MigrationInterface, QueryRunner } from 'typeorm';

export class CreateNotificationTable1717147942177
  implements MigrationInterface {
  name = 'CreateNotificationTable1717147942177';

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TYPE "public"."notification_type_enum" AS ENUM('post', 'comment', 'reaction')`
    );
    await queryRunner.query(
      `CREATE TABLE "notification" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "type" "public"."notification_type_enum" NOT NULL, "resourceId" character varying NOT NULL, "message" character varying NOT NULL, "createdAt" TIMESTAMP NOT NULL DEFAULT now(), "leaveRequestId" uuid, CONSTRAINT "PK_705b6c7cdf9b2c2ff7ac7872cb7" PRIMARY KEY ("id"))`
    );
    await queryRunner.query(
      `ALTER TABLE "notification" ADD CONSTRAINT "FK_d7dcd7fa90cc4542719b880bc7f" FOREIGN KEY ("leaveRequestId") REFERENCES "leave_request"("id") ON DELETE SET NULL ON UPDATE NO ACTION`
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "notification" DROP CONSTRAINT "FK_d7dcd7fa90cc4542719b880bc7f"`
    );
    await queryRunner.query(`DROP TABLE "notification"`);
    await queryRunner.query(`DROP TYPE "public"."notification_type_enum"`);
  }
}


1			import { MigrationInterface, QueryRunner } from 'typeorm';
2
3			export class CreateNotificationTable1717147942177
4			implements MigrationInterface {
5			name = 'CreateNotificationTable1717147942177';
6
7			public async up(queryRunner: QueryRunner): Promise<void> {
8			await queryRunner.query(
9			`CREATE TYPE "public"."notification_type_enum" AS ENUM('post', 'comment', 'reaction')`
10			);
11			await queryRunner.query(
12			`CREATE TABLE "notification" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "type" "public"."notification_type_enum" NOT NULL, "resourceId" character varying NOT NULL, "message" character varying NOT NULL, "createdAt" TIMESTAMP NOT NULL DEFAULT now(), "leaveRequestId" uuid, CONSTRAINT "PK_705b6c7cdf9b2c2ff7ac7872cb7" PRIMARY KEY ("id"))`
13			);
14			await queryRunner.query(
15			`ALTER TABLE "notification" ADD CONSTRAINT "FK_d7dcd7fa90cc4542719b880bc7f" FOREIGN KEY ("leaveRequestId") REFERENCES "leave_request"("id") ON DELETE SET NULL ON UPDATE NO ACTION`
16			);
17			}
18
19			public async down(queryRunner: QueryRunner): Promise<void> {
20			await queryRunner.query(
21			`ALTER TABLE "notification" DROP CONSTRAINT "FK_d7dcd7fa90cc4542719b880bc7f"`
22			);
23			await queryRunner.query(`DROP TABLE "notification"`);
24			await queryRunner.query(`DROP TYPE "public"."notification_type_enum"`);
25			}
26			}
27

fairnesscoop / permacoop

Pull Request — master (#436)

CreateNotificationTable1717147942177.up A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like